Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 119210 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 8161 |
| Duplicate rows (%) | 6.8% |
| Total size in memory | 98.7 MiB |
| Average record size in memory | 868.2 B |
Variable types
| Categorical | 16 |
|---|---|
| Numeric | 14 |
| Text | 1 |
| DateTime | 1 |
| Dataset has 8161 (6.8%) duplicate rows | Duplicates |
children is highly imbalanced (80.6%) | Imbalance |
babies is highly imbalanced (97.1%) | Imbalance |
distribution_channel is highly imbalanced (63.2%) | Imbalance |
is_repeated_guest is highly imbalanced (79.8%) | Imbalance |
reserved_room_type is highly imbalanced (56.3%) | Imbalance |
deposit_type is highly imbalanced (65.3%) | Imbalance |
customer_type is highly imbalanced (50.6%) | Imbalance |
required_car_parking_spaces is highly imbalanced (85.4%) | Imbalance |
previous_cancellations is highly skewed (γ1 = 24.44392359) | Skewed |
previous_bookings_not_canceled is highly skewed (γ1 = 23.53955539) | Skewed |
lead_time has 6264 (5.3%) zeros | Zeros |
stays_in_weekend_nights has 51895 (43.5%) zeros | Zeros |
stays_in_week_nights has 7572 (6.4%) zeros | Zeros |
previous_cancellations has 112731 (94.6%) zeros | Zeros |
previous_bookings_not_canceled has 115597 (97.0%) zeros | Zeros |
booking_changes has 101232 (84.9%) zeros | Zeros |
agent has 16280 (13.7%) zeros | Zeros |
company has 112442 (94.3%) zeros | Zeros |
days_in_waiting_list has 115517 (96.9%) zeros | Zeros |
adr has 1810 (1.5%) zeros | Zeros |
total_of_special_requests has 70201 (58.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-05-29 08:33:11.419978 |
|---|---|
| Analysis finished | 2024-05-29 08:33:38.955456 |
| Duration | 27.54 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
hotel
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.7 MiB |
| City Hotel | |
|---|---|
| Resort Hotel |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.671873 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1272194 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Resort Hotel |
|---|---|
| 2nd row | Resort Hotel |
| 3rd row | Resort Hotel |
| 4th row | Resort Hotel |
| 5th row | Resort Hotel |
Common Values
| Value | Count | Frequency (%) |
| City Hotel | 79163 | |
| Resort Hotel | 40047 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| hotel | 119210 | |
| city | 79163 | |
| resort | 40047 | 16.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 238420 | |
| o | 159257 | |
| e | 159257 | |
| 119210 | ||
| H | 119210 | |
| l | 119210 | |
| C | 79163 | 6.2% |
| i | 79163 | 6.2% |
| y | 79163 | 6.2% |
| R | 40047 | 3.1% |
| Other values (2) | 80094 | 6.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 914564 | |
| Uppercase Letter | 238420 | 18.7% |
| Space Separator | 119210 | 9.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 238420 | |
| o | 159257 | |
| e | 159257 | |
| l | 119210 | |
| i | 79163 | 8.7% |
| y | 79163 | 8.7% |
| s | 40047 | 4.4% |
| r | 40047 | 4.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 119210 | |
| C | 79163 | |
| R | 40047 | 16.8% |
Space Separator
| Value | Count | Frequency (%) |
| 119210 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1152984 | |
| Common | 119210 | 9.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 238420 | |
| o | 159257 | |
| e | 159257 | |
| H | 119210 | |
| l | 119210 | |
| C | 79163 | 6.9% |
| i | 79163 | 6.9% |
| y | 79163 | 6.9% |
| R | 40047 | 3.5% |
| s | 40047 | 3.5% |
Common
| Value | Count | Frequency (%) |
| 119210 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1272194 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 238420 | |
| o | 159257 | |
| e | 159257 | |
| 119210 | ||
| H | 119210 | |
| l | 119210 | |
| C | 79163 | 6.2% |
| i | 79163 | 6.2% |
| y | 79163 | 6.2% |
| R | 40047 | 3.1% |
| Other values (2) | 80094 | 6.3% |
is_canceled
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 119210 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 75011 | |
| 1 | 44199 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 75011 | |
| 1 | 44199 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 75011 | |
| 1 | 44199 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 119210 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 75011 | |
| 1 | 44199 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 119210 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 75011 | |
| 1 | 44199 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 119210 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 75011 | |
| 1 | 44199 |
lead_time
Real number (ℝ)
ZEROS
| Distinct | 479 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 104.10923 |
| Minimum | 0 |
|---|---|
| Maximum | 737 |
| Zeros | 6264 |
| Zeros (%) | 5.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 18 |
| median | 69 |
| Q3 | 161 |
| 95-th percentile | 320 |
| Maximum | 737 |
| Range | 737 |
| Interquartile range (IQR) | 143 |
Descriptive statistics
| Standard deviation | 106.87545 |
|---|---|
| Coefficient of variation (CV) | 1.0265704 |
| Kurtosis | 1.6943723 |
| Mean | 104.10923 |
| Median Absolute Deviation (MAD) | 60 |
| Skewness | 1.3458092 |
| Sum | 12410861 |
| Variance | 11422.362 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 6264 | 5.3% |
| 1 | 3445 | 2.9% |
| 2 | 2065 | 1.7% |
| 3 | 1815 | 1.5% |
| 4 | 1710 | 1.4% |
| 5 | 1563 | 1.3% |
| 6 | 1444 | 1.2% |
| 7 | 1329 | 1.1% |
| 8 | 1138 | 1.0% |
| 12 | 1079 | 0.9% |
| Other values (469) | 97358 |
| Value | Count | Frequency (%) |
| 0 | 6264 | |
| 1 | 3445 | |
| 2 | 2065 | 1.7% |
| 3 | 1815 | 1.5% |
| 4 | 1710 | 1.4% |
| 5 | 1563 | 1.3% |
| 6 | 1444 | 1.2% |
| 7 | 1329 | 1.1% |
| 8 | 1138 | 1.0% |
| 9 | 991 | 0.8% |
| Value | Count | Frequency (%) |
| 737 | 1 | < 0.1% |
| 709 | 1 | < 0.1% |
| 629 | 17 | |
| 626 | 30 | |
| 622 | 17 | |
| 615 | 17 | |
| 608 | 17 | |
| 605 | 30 | |
| 601 | 17 | |
| 594 | 17 |
arrival_date_year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.0 MiB |
| 2016 | |
|---|---|
| 2017 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 476840 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2016 | 56623 | |
| 2017 | 40620 | |
| 2015 | 21967 | 18.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2016 | 56623 | |
| 2017 | 40620 | |
| 2015 | 21967 | 18.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 119210 | |
| 0 | 119210 | |
| 1 | 119210 | |
| 6 | 56623 | |
| 7 | 40620 | 8.5% |
| 5 | 21967 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 476840 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 119210 | |
| 0 | 119210 | |
| 1 | 119210 | |
| 6 | 56623 | |
| 7 | 40620 | 8.5% |
| 5 | 21967 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 476840 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 119210 | |
| 0 | 119210 | |
| 1 | 119210 | |
| 6 | 56623 | |
| 7 | 40620 | 8.5% |
| 5 | 21967 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 476840 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 119210 | |
| 0 | 119210 | |
| 1 | 119210 | |
| 6 | 56623 | |
| 7 | 40620 | 8.5% |
| 5 | 21967 | 4.6% |
arrival_date_month
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| August | |
|---|---|
| July | |
| May | |
| October | |
| April | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 5.9026927 |
| Min length | 3 |
Characters and Unicode
| Total characters | 703660 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | July |
|---|---|
| 2nd row | July |
| 3rd row | July |
| 4th row | July |
| 5th row | July |
Common Values
| Value | Count | Frequency (%) |
| August | 13861 | |
| July | 12644 | |
| May | 11780 | |
| October | 11147 | |
| April | 11078 | |
| June | 10929 | |
| September | 10500 | |
| March | 9768 | |
| February | 8052 | |
| November | 6771 | |
| Other values (2) | 12680 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| august | 13861 | |
| july | 12644 | |
| may | 11780 | |
| october | 11147 | |
| april | 11078 | |
| june | 10929 | |
| september | 10500 | |
| march | 9768 | |
| february | 8052 | |
| november | 6771 | |
| Other values (2) | 12680 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 95447 | |
| r | 78048 | 11.1% |
| u | 65268 | 9.3% |
| b | 43229 | 6.1% |
| a | 41442 | 5.9% |
| y | 38397 | 5.5% |
| t | 35508 | 5.0% |
| J | 29494 | 4.2% |
| c | 27674 | 3.9% |
| A | 24939 | 3.5% |
| Other values (16) | 224214 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 584450 | |
| Uppercase Letter | 119210 | 16.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 95447 | |
| r | 78048 | |
| u | 65268 | |
| b | 43229 | 7.4% |
| a | 41442 | 7.1% |
| y | 38397 | 6.6% |
| t | 35508 | 6.1% |
| c | 27674 | 4.7% |
| m | 24030 | 4.1% |
| l | 23722 | 4.1% |
| Other values (8) | 111685 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 29494 | |
| A | 24939 | |
| M | 21548 | |
| O | 11147 | 9.4% |
| S | 10500 | 8.8% |
| F | 8052 | 6.8% |
| N | 6771 | 5.7% |
| D | 6759 | 5.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 703660 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 95447 | |
| r | 78048 | 11.1% |
| u | 65268 | 9.3% |
| b | 43229 | 6.1% |
| a | 41442 | 5.9% |
| y | 38397 | 5.5% |
| t | 35508 | 5.0% |
| J | 29494 | 4.2% |
| c | 27674 | 3.9% |
| A | 24939 | 3.5% |
| Other values (16) | 224214 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 703660 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 95447 | |
| r | 78048 | 11.1% |
| u | 65268 | 9.3% |
| b | 43229 | 6.1% |
| a | 41442 | 5.9% |
| y | 38397 | 5.5% |
| t | 35508 | 5.0% |
| J | 29494 | 4.2% |
| c | 27674 | 3.9% |
| A | 24939 | 3.5% |
| Other values (16) | 224214 |
arrival_date_week_number
Real number (ℝ)
| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.163376 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 28 |
| Q3 | 38 |
| 95-th percentile | 49 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.601107 |
|---|---|
| Coefficient of variation (CV) | 0.5007149 |
| Kurtosis | -0.98542287 |
| Mean | 27.163376 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.010198696 |
| Sum | 3238146 |
| Variance | 184.99011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 33 | 3576 | 3.0% |
| 30 | 3082 | 2.6% |
| 32 | 3041 | 2.6% |
| 34 | 3039 | 2.5% |
| 18 | 2923 | 2.5% |
| 21 | 2853 | 2.4% |
| 28 | 2843 | 2.4% |
| 17 | 2803 | 2.4% |
| 20 | 2781 | 2.3% |
| 29 | 2763 | 2.3% |
| Other values (43) | 89506 |
| Value | Count | Frequency (%) |
| 1 | 1045 | |
| 2 | 1216 | |
| 3 | 1318 | |
| 4 | 1485 | |
| 5 | 1385 | |
| 6 | 1507 | |
| 7 | 2102 | |
| 8 | 2212 | |
| 9 | 2109 | |
| 10 | 2142 |
| Value | Count | Frequency (%) |
| 53 | 1811 | |
| 52 | 1187 | |
| 51 | 933 | |
| 50 | 1498 | |
| 49 | 1780 | |
| 48 | 1495 | |
| 47 | 1677 | |
| 46 | 1570 | |
| 45 | 1940 | |
| 44 | 2270 |
arrival_date_day_of_month
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.798717 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7810701 |
|---|---|
| Coefficient of variation (CV) | 0.55580908 |
| Kurtosis | -1.1870963 |
| Mean | 15.798717 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.0021109856 |
| Sum | 1883365 |
| Variance | 77.107192 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 17 | 4401 | 3.7% |
| 5 | 4310 | 3.6% |
| 15 | 4188 | 3.5% |
| 25 | 4155 | 3.5% |
| 26 | 4141 | 3.5% |
| 9 | 4090 | 3.4% |
| 12 | 4082 | 3.4% |
| 16 | 4071 | 3.4% |
| 2 | 4054 | 3.4% |
| 19 | 4048 | 3.4% |
| Other values (21) | 77670 |
| Value | Count | Frequency (%) |
| 1 | 3620 | |
| 2 | 4054 | |
| 3 | 3847 | |
| 4 | 3760 | |
| 5 | 4310 | |
| 6 | 3819 | |
| 7 | 3658 | |
| 8 | 3919 | |
| 9 | 4090 | |
| 10 | 3569 |
| Value | Count | Frequency (%) |
| 31 | 2207 | |
| 30 | 3844 | |
| 29 | 3580 | |
| 28 | 3942 | |
| 27 | 3791 | |
| 26 | 4141 | |
| 25 | 4155 | |
| 24 | 3983 | |
| 23 | 3612 | |
| 22 | 3593 |
stays_in_weekend_nights
Real number (ℝ)
ZEROS
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9270531 |
| Minimum | 0 |
|---|---|
| Maximum | 19 |
| Zeros | 51895 |
| Zeros (%) | 43.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.99511703 |
|---|---|
| Coefficient of variation (CV) | 1.0734197 |
| Kurtosis | 6.3653972 |
| Mean | 0.9270531 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.3202425 |
| Sum | 110514 |
| Variance | 0.9902579 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 0 | 51895 | |
| 2 | 33266 | |
| 1 | 30615 | |
| 4 | 1847 | 1.5% |
| 3 | 1252 | 1.1% |
| 6 | 152 | 0.1% |
| 5 | 77 | 0.1% |
| 8 | 58 | < 0.1% |
| 7 | 19 | < 0.1% |
| 9 | 10 | < 0.1% |
| Other values (7) | 19 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 51895 | |
| 1 | 30615 | |
| 2 | 33266 | |
| 3 | 1252 | 1.1% |
| 4 | 1847 | 1.5% |
| 5 | 77 | 0.1% |
| 6 | 152 | 0.1% |
| 7 | 19 | < 0.1% |
| 8 | 58 | < 0.1% |
| 9 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 19 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 16 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 2 | < 0.1% |
| 12 | 5 | < 0.1% |
| 10 | 7 | < 0.1% |
| 9 | 10 | < 0.1% |
| 8 | 58 | |
| 7 | 19 | < 0.1% |
stays_in_week_nights
Real number (ℝ)
ZEROS
| Distinct | 33 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4991947 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 7572 |
| Zeros (%) | 6.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.8971058 |
|---|---|
| Coefficient of variation (CV) | 0.75908683 |
| Kurtosis | 22.250866 |
| Mean | 2.4991947 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.7548629 |
| Sum | 297929 |
| Variance | 3.5990103 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=33)
| Value | Count | Frequency (%) |
| 2 | 33670 | |
| 1 | 30292 | |
| 3 | 22241 | |
| 5 | 11068 | 9.3% |
| 4 | 9543 | 8.0% |
| 0 | 7572 | 6.4% |
| 6 | 1494 | 1.3% |
| 10 | 1030 | 0.9% |
| 7 | 1024 | 0.9% |
| 8 | 654 | 0.5% |
| Other values (23) | 622 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 7572 | 6.4% |
| 1 | 30292 | |
| 2 | 33670 | |
| 3 | 22241 | |
| 4 | 9543 | 8.0% |
| 5 | 11068 | 9.3% |
| 6 | 1494 | 1.3% |
| 7 | 1024 | 0.9% |
| 8 | 654 | 0.5% |
| 9 | 228 | 0.2% |
| Value | Count | Frequency (%) |
| 50 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 40 | 2 | < 0.1% |
| 34 | 1 | < 0.1% |
| 33 | 1 | < 0.1% |
| 32 | 1 | < 0.1% |
| 30 | 4 | |
| 26 | 1 | < 0.1% |
| 25 | 6 | |
| 24 | 3 |
adults
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8592064 |
| Minimum | 0 |
|---|---|
| Maximum | 55 |
| Zeros | 223 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 55 |
| Range | 55 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.57518558 |
|---|---|
| Coefficient of variation (CV) | 0.30937155 |
| Kurtosis | 1392.5063 |
| Mean | 1.8592064 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 18.774333 |
| Sum | 221636 |
| Variance | 0.33083845 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 2 | 89680 | |
| 1 | 23027 | 19.3% |
| 3 | 6202 | 5.2% |
| 0 | 223 | 0.2% |
| 4 | 62 | 0.1% |
| 26 | 5 | < 0.1% |
| 27 | 2 | < 0.1% |
| 20 | 2 | < 0.1% |
| 5 | 2 | < 0.1% |
| 40 | 1 | < 0.1% |
| Other values (4) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 223 | 0.2% |
| 1 | 23027 | 19.3% |
| 2 | 89680 | |
| 3 | 6202 | 5.2% |
| 4 | 62 | 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 26 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 55 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 27 | 2 | < 0.1% |
| 26 | 5 | < 0.1% |
| 20 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 4 | 62 |
children
Categorical
IMBALANCE
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 MiB |
| 0.0 | |
|---|---|
| 1.0 | 4861 |
| 2.0 | 3652 |
| 3.0 | 76 |
| 10.0 | 1 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0000084 |
| Min length | 3 |
Characters and Unicode
| Total characters | 357631 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 110620 | |
| 1.0 | 4861 | 4.1% |
| 2.0 | 3652 | 3.1% |
| 3.0 | 76 | 0.1% |
| 10.0 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 110620 | |
| 1.0 | 4861 | 4.1% |
| 2.0 | 3652 | 3.1% |
| 3.0 | 76 | 0.1% |
| 10.0 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 229831 | |
| . | 119210 | |
| 1 | 4862 | 1.4% |
| 2 | 3652 | 1.0% |
| 3 | 76 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 238421 | |
| Other Punctuation | 119210 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 229831 | |
| 1 | 4862 | 2.0% |
| 2 | 3652 | 1.5% |
| 3 | 76 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 119210 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 357631 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 229831 | |
| . | 119210 | |
| 1 | 4862 | 1.4% |
| 2 | 3652 | 1.0% |
| 3 | 76 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 357631 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 229831 | |
| . | 119210 | |
| 1 | 4862 | 1.4% |
| 2 | 3652 | 1.0% |
| 3 | 76 | < 0.1% |
babies
Categorical
IMBALANCE
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 MiB |
| 0 | |
|---|---|
| 1 | 900 |
| 2 | 15 |
| 10 | 1 |
| 9 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.0000084 |
| Min length | 1 |
Characters and Unicode
| Total characters | 119211 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 118293 | |
| 1 | 900 | 0.8% |
| 2 | 15 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 118293 | |
| 1 | 900 | 0.8% |
| 2 | 15 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 118294 | |
| 1 | 901 | 0.8% |
| 2 | 15 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 119211 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 118294 | |
| 1 | 901 | 0.8% |
| 2 | 15 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 119211 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 118294 | |
| 1 | 901 | 0.8% |
| 2 | 15 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 119211 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 118294 | |
| 1 | 901 | 0.8% |
| 2 | 15 | < 0.1% |
| 9 | 1 | < 0.1% |
meal
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.7 MiB |
| BB | |
|---|---|
| HB | |
| SC | |
| FB | 798 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 238420 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | BB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
Common Values
| Value | Count | Frequency (%) |
| BB | 92236 | |
| HB | 14458 | 12.1% |
| SC | 11718 | 9.8% |
| FB | 798 | 0.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| bb | 92236 | |
| hb | 14458 | 12.1% |
| sc | 11718 | 9.8% |
| fb | 798 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 199728 | |
| H | 14458 | 6.1% |
| S | 11718 | 4.9% |
| C | 11718 | 4.9% |
| F | 798 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 238420 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 199728 | |
| H | 14458 | 6.1% |
| S | 11718 | 4.9% |
| C | 11718 | 4.9% |
| F | 798 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 238420 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 199728 | |
| H | 14458 | 6.1% |
| S | 11718 | 4.9% |
| C | 11718 | 4.9% |
| F | 798 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 238420 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| B | 199728 | |
| H | 14458 | 6.1% |
| S | 11718 | 4.9% |
| C | 11718 | 4.9% |
| F | 798 | 0.3% |
country
Text
| Distinct | 178 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 MiB |
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 3.00531 |
| Min length | 2 |
Characters and Unicode
| Total characters | 358263 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 30 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PRT |
|---|---|
| 2nd row | PRT |
| 3rd row | GBR |
| 4th row | GBR |
| 5th row | GBR |
| Value | Count | Frequency (%) |
| prt | 48483 | |
| gbr | 12120 | 10.2% |
| fra | 10401 | 8.7% |
| esp | 8560 | 7.2% |
| deu | 7285 | 6.1% |
| ita | 3761 | 3.2% |
| irl | 3374 | 2.8% |
| bel | 2342 | 2.0% |
| bra | 2222 | 1.9% |
| nld | 2103 | 1.8% |
| Other values (168) | 18559 | 15.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 80668 | |
| P | 58389 | |
| T | 54151 | |
| A | 21602 | 6.0% |
| E | 21520 | 6.0% |
| B | 17040 | 4.8% |
| S | 13911 | 3.9% |
| U | 13762 | 3.8% |
| G | 13120 | 3.7% |
| F | 10941 | 3.1% |
| Other values (20) | 53159 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 355395 | |
| Lowercase Letter | 2868 | 0.8% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 80668 | |
| P | 58389 | |
| T | 54151 | |
| A | 21602 | 6.1% |
| E | 21520 | 6.1% |
| B | 17040 | 4.8% |
| S | 13911 | 3.9% |
| U | 13762 | 3.9% |
| G | 13120 | 3.7% |
| F | 10941 | 3.1% |
| Other values (16) | 50291 |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 1434 | |
| k | 478 | 16.7% |
| o | 478 | 16.7% |
| w | 478 | 16.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 358263 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 80668 | |
| P | 58389 | |
| T | 54151 | |
| A | 21602 | 6.0% |
| E | 21520 | 6.0% |
| B | 17040 | 4.8% |
| S | 13911 | 3.9% |
| U | 13762 | 3.8% |
| G | 13120 | 3.7% |
| F | 10941 | 3.1% |
| Other values (20) | 53159 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 358263 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 80668 | |
| P | 58389 | |
| T | 54151 | |
| A | 21602 | 6.0% |
| E | 21520 | 6.0% |
| B | 17040 | 4.8% |
| S | 13911 | 3.9% |
| U | 13762 | 3.8% |
| G | 13120 | 3.7% |
| F | 10941 | 3.1% |
| Other values (20) | 53159 |
market_segment
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.5 MiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Groups | |
| Direct | |
| Corporate | 5282 |
| Other values (3) | 965 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.0191762 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1075176 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Corporate |
| 5th row | Online TA |
Common Values
| Value | Count | Frequency (%) |
| Online TA | 56408 | |
| Offline TA/TO | 24182 | |
| Groups | 19791 | 16.6% |
| Direct | 12582 | 10.6% |
| Corporate | 5282 | 4.4% |
| Complementary | 728 | 0.6% |
| Aviation | 235 | 0.2% |
| Undefined | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| online | 56408 | |
| ta | 56408 | |
| offline | 24182 | |
| ta/to | 24182 | |
| groups | 19791 | 9.9% |
| direct | 12582 | 6.3% |
| corporate | 5282 | 2.6% |
| complementary | 728 | 0.4% |
| aviation | 235 | 0.1% |
| undefined | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 137965 | |
| O | 104772 | |
| T | 104772 | |
| e | 99914 | |
| i | 93644 | |
| l | 81318 | |
| A | 80825 | |
| 80590 | ||
| f | 48366 | 4.5% |
| r | 43665 | 4.1% |
| Other values (16) | 199345 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 641650 | |
| Uppercase Letter | 328754 | |
| Space Separator | 80590 | 7.5% |
| Other Punctuation | 24182 | 2.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 137965 | |
| e | 99914 | |
| i | 93644 | |
| l | 81318 | |
| f | 48366 | 7.5% |
| r | 43665 | 6.8% |
| o | 31318 | 4.9% |
| p | 25801 | 4.0% |
| s | 19791 | 3.1% |
| u | 19791 | 3.1% |
| Other values (7) | 40077 | 6.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 104772 | |
| T | 104772 | |
| A | 80825 | |
| G | 19791 | 6.0% |
| D | 12582 | 3.8% |
| C | 6010 | 1.8% |
| U | 2 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 80590 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 24182 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 970404 | |
| Common | 104772 | 9.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 137965 | |
| O | 104772 | |
| T | 104772 | |
| e | 99914 | |
| i | 93644 | |
| l | 81318 | |
| A | 80825 | |
| f | 48366 | 5.0% |
| r | 43665 | 4.5% |
| o | 31318 | 3.2% |
| Other values (14) | 143845 |
Common
| Value | Count | Frequency (%) |
| 80590 | ||
| / | 24182 | 23.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1075176 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 137965 | |
| O | 104772 | |
| T | 104772 | |
| e | 99914 | |
| i | 93644 | |
| l | 81318 | |
| A | 80825 | |
| 80590 | ||
| f | 48366 | 4.5% |
| r | 43665 | 4.1% |
| Other values (16) | 199345 |
distribution_channel
Categorical
IMBALANCE
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 MiB |
| TA/TO | |
|---|---|
| Direct | |
| Corporate | 6651 |
| GDS | 193 |
| Undefined | 5 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.3426642 |
| Min length | 3 |
Characters and Unicode
| Total characters | 636899 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Corporate |
| 5th row | TA/TO |
Common Values
| Value | Count | Frequency (%) |
| TA/TO | 97750 | |
| Direct | 14611 | 12.3% |
| Corporate | 6651 | 5.6% |
| GDS | 193 | 0.2% |
| Undefined | 5 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ta/to | 97750 | |
| direct | 14611 | 12.3% |
| corporate | 6651 | 5.6% |
| gds | 193 | 0.2% |
| undefined | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 195500 | |
| / | 97750 | |
| O | 97750 | |
| A | 97750 | |
| r | 27913 | 4.4% |
| e | 21272 | 3.3% |
| t | 21262 | 3.3% |
| D | 14804 | 2.3% |
| i | 14616 | 2.3% |
| c | 14611 | 2.3% |
| Other values (10) | 33671 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 412846 | |
| Lowercase Letter | 126303 | 19.8% |
| Other Punctuation | 97750 | 15.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 27913 | |
| e | 21272 | |
| t | 21262 | |
| i | 14616 | |
| c | 14611 | |
| o | 13302 | |
| a | 6651 | 5.3% |
| p | 6651 | 5.3% |
| n | 10 | < 0.1% |
| d | 10 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 195500 | |
| O | 97750 | |
| A | 97750 | |
| D | 14804 | 3.6% |
| C | 6651 | 1.6% |
| G | 193 | < 0.1% |
| S | 193 | < 0.1% |
| U | 5 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 97750 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 539149 | |
| Common | 97750 | 15.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 195500 | |
| O | 97750 | |
| A | 97750 | |
| r | 27913 | 5.2% |
| e | 21272 | 3.9% |
| t | 21262 | 3.9% |
| D | 14804 | 2.7% |
| i | 14616 | 2.7% |
| c | 14611 | 2.7% |
| o | 13302 | 2.5% |
| Other values (9) | 20369 | 3.8% |
Common
| Value | Count | Frequency (%) |
| / | 97750 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 636899 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 195500 | |
| / | 97750 | |
| O | 97750 | |
| A | 97750 | |
| r | 27913 | 4.4% |
| e | 21272 | 3.3% |
| t | 21262 | 3.3% |
| D | 14804 | 2.3% |
| i | 14616 | 2.3% |
| c | 14611 | 2.3% |
| Other values (10) | 33671 | 5.3% |
is_repeated_guest
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 MiB |
| 0 | |
|---|---|
| 1 | 3755 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 119210 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 115455 | |
| 1 | 3755 | 3.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 115455 | |
| 1 | 3755 | 3.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 115455 | |
| 1 | 3755 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 119210 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 115455 | |
| 1 | 3755 | 3.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 119210 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 115455 | |
| 1 | 3755 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 119210 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 115455 | |
| 1 | 3755 | 3.1% |
previous_cancellations
Real number (ℝ)
SKEWED ZEROS
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.087190672 |
| Minimum | 0 |
|---|---|
| Maximum | 26 |
| Zeros | 112731 |
| Zeros (%) | 94.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.84491826 |
|---|---|
| Coefficient of variation (CV) | 9.6904663 |
| Kurtosis | 673.22115 |
| Mean | 0.087190672 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.443924 |
| Sum | 10394 |
| Variance | 0.71388687 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 0 | 112731 | |
| 1 | 6048 | 5.1% |
| 2 | 114 | 0.1% |
| 3 | 65 | 0.1% |
| 24 | 48 | < 0.1% |
| 11 | 35 | < 0.1% |
| 4 | 31 | < 0.1% |
| 26 | 26 | < 0.1% |
| 25 | 25 | < 0.1% |
| 6 | 22 | < 0.1% |
| Other values (5) | 65 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 112731 | |
| 1 | 6048 | 5.1% |
| 2 | 114 | 0.1% |
| 3 | 65 | 0.1% |
| 4 | 31 | < 0.1% |
| 5 | 19 | < 0.1% |
| 6 | 22 | < 0.1% |
| 11 | 35 | < 0.1% |
| 13 | 12 | < 0.1% |
| 14 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 26 | 26 | |
| 25 | 25 | |
| 24 | 48 | |
| 21 | 1 | < 0.1% |
| 19 | 19 | < 0.1% |
| 14 | 14 | < 0.1% |
| 13 | 12 | < 0.1% |
| 11 | 35 | |
| 6 | 22 | |
| 5 | 19 | < 0.1% |
previous_bookings_not_canceled
Real number (ℝ)
SKEWED ZEROS
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1370942 |
| Minimum | 0 |
|---|---|
| Maximum | 72 |
| Zeros | 115597 |
| Zeros (%) | 97.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.4981372 |
|---|---|
| Coefficient of variation (CV) | 10.927794 |
| Kurtosis | 766.95283 |
| Mean | 0.1370942 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 23.539555 |
| Sum | 16343 |
| Variance | 2.244415 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 115597 | |
| 1 | 1538 | 1.3% |
| 2 | 580 | 0.5% |
| 3 | 333 | 0.3% |
| 4 | 229 | 0.2% |
| 5 | 181 | 0.2% |
| 6 | 113 | 0.1% |
| 7 | 88 | 0.1% |
| 8 | 70 | 0.1% |
| 9 | 59 | < 0.1% |
| Other values (63) | 422 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 115597 | |
| 1 | 1538 | 1.3% |
| 2 | 580 | 0.5% |
| 3 | 333 | 0.3% |
| 4 | 229 | 0.2% |
| 5 | 181 | 0.2% |
| 6 | 113 | 0.1% |
| 7 | 88 | 0.1% |
| 8 | 70 | 0.1% |
| 9 | 59 | < 0.1% |
| Value | Count | Frequency (%) |
| 72 | 1 | |
| 71 | 1 | |
| 70 | 1 | |
| 69 | 1 | |
| 68 | 1 | |
| 67 | 1 | |
| 66 | 1 | |
| 65 | 1 | |
| 64 | 1 | |
| 63 | 1 |
reserved_room_type
Categorical
IMBALANCE
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 MiB |
| A | |
|---|---|
| D | |
| E | 6519 |
| F | 2894 |
| G | 2092 |
| Other values (4) | 2653 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 119210 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 85873 | |
| D | 19179 | 16.1% |
| E | 6519 | 5.5% |
| F | 2894 | 2.4% |
| G | 2092 | 1.8% |
| B | 1115 | 0.9% |
| C | 931 | 0.8% |
| H | 601 | 0.5% |
| L | 6 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 85873 | |
| d | 19179 | 16.1% |
| e | 6519 | 5.5% |
| f | 2894 | 2.4% |
| g | 2092 | 1.8% |
| b | 1115 | 0.9% |
| c | 931 | 0.8% |
| h | 601 | 0.5% |
| l | 6 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 85873 | |
| D | 19179 | 16.1% |
| E | 6519 | 5.5% |
| F | 2894 | 2.4% |
| G | 2092 | 1.8% |
| B | 1115 | 0.9% |
| C | 931 | 0.8% |
| H | 601 | 0.5% |
| L | 6 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 119210 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 85873 | |
| D | 19179 | 16.1% |
| E | 6519 | 5.5% |
| F | 2894 | 2.4% |
| G | 2092 | 1.8% |
| B | 1115 | 0.9% |
| C | 931 | 0.8% |
| H | 601 | 0.5% |
| L | 6 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 119210 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 85873 | |
| D | 19179 | 16.1% |
| E | 6519 | 5.5% |
| F | 2894 | 2.4% |
| G | 2092 | 1.8% |
| B | 1115 | 0.9% |
| C | 931 | 0.8% |
| H | 601 | 0.5% |
| L | 6 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 119210 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 85873 | |
| D | 19179 | 16.1% |
| E | 6519 | 5.5% |
| F | 2894 | 2.4% |
| G | 2092 | 1.8% |
| B | 1115 | 0.9% |
| C | 931 | 0.8% |
| H | 601 | 0.5% |
| L | 6 | < 0.1% |
assigned_room_type
Categorical
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 MiB |
| A | |
|---|---|
| D | |
| E | |
| F | 3751 |
| G | 2549 |
| Other values (6) | 5783 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 119210 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | C |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 74020 | |
| D | 25309 | 21.2% |
| E | 7798 | 6.5% |
| F | 3751 | 3.1% |
| G | 2549 | 2.1% |
| C | 2370 | 2.0% |
| B | 2154 | 1.8% |
| H | 712 | 0.6% |
| I | 359 | 0.3% |
| K | 187 | 0.2% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| a | 74020 | |
| d | 25309 | 21.2% |
| e | 7798 | 6.5% |
| f | 3751 | 3.1% |
| g | 2549 | 2.1% |
| c | 2370 | 2.0% |
| b | 2154 | 1.8% |
| h | 712 | 0.6% |
| i | 359 | 0.3% |
| k | 187 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 74020 | |
| D | 25309 | 21.2% |
| E | 7798 | 6.5% |
| F | 3751 | 3.1% |
| G | 2549 | 2.1% |
| C | 2370 | 2.0% |
| B | 2154 | 1.8% |
| H | 712 | 0.6% |
| I | 359 | 0.3% |
| K | 187 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 119210 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 74020 | |
| D | 25309 | 21.2% |
| E | 7798 | 6.5% |
| F | 3751 | 3.1% |
| G | 2549 | 2.1% |
| C | 2370 | 2.0% |
| B | 2154 | 1.8% |
| H | 712 | 0.6% |
| I | 359 | 0.3% |
| K | 187 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 119210 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 74020 | |
| D | 25309 | 21.2% |
| E | 7798 | 6.5% |
| F | 3751 | 3.1% |
| G | 2549 | 2.1% |
| C | 2370 | 2.0% |
| B | 2154 | 1.8% |
| H | 712 | 0.6% |
| I | 359 | 0.3% |
| K | 187 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 119210 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 74020 | |
| D | 25309 | 21.2% |
| E | 7798 | 6.5% |
| F | 3751 | 3.1% |
| G | 2549 | 2.1% |
| C | 2370 | 2.0% |
| B | 2154 | 1.8% |
| H | 712 | 0.6% |
| I | 359 | 0.3% |
| K | 187 | 0.2% |
booking_changes
Real number (ℝ)
ZEROS
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.21879876 |
| Minimum | 0 |
|---|---|
| Maximum | 18 |
| Zeros | 101232 |
| Zeros (%) | 84.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 18 |
| Range | 18 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.63850446 |
|---|---|
| Coefficient of variation (CV) | 2.9182271 |
| Kurtosis | 63.437992 |
| Mean | 0.21879876 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.5000578 |
| Sum | 26083 |
| Variance | 0.40768794 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=19)
| Value | Count | Frequency (%) |
| 0 | 101232 | |
| 1 | 12666 | 10.6% |
| 2 | 3780 | 3.2% |
| 3 | 914 | 0.8% |
| 4 | 367 | 0.3% |
| 5 | 115 | 0.1% |
| 6 | 61 | 0.1% |
| 7 | 29 | < 0.1% |
| 8 | 14 | < 0.1% |
| 9 | 8 | < 0.1% |
| Other values (9) | 24 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 101232 | |
| 1 | 12666 | 10.6% |
| 2 | 3780 | 3.2% |
| 3 | 914 | 0.8% |
| 4 | 367 | 0.3% |
| 5 | 115 | 0.1% |
| 6 | 61 | 0.1% |
| 7 | 29 | < 0.1% |
| 8 | 14 | < 0.1% |
| 9 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 18 | 1 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 2 | < 0.1% |
| 15 | 3 | < 0.1% |
| 14 | 3 | < 0.1% |
| 13 | 5 | |
| 12 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 10 | 6 | |
| 9 | 8 |
deposit_type
Categorical
IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.6 MiB |
| No Deposit | |
|---|---|
| Non Refund | |
| Refundable | 162 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1192100 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
Common Values
| Value | Count | Frequency (%) |
| No Deposit | 104461 | |
| Non Refund | 14587 | 12.2% |
| Refundable | 162 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 104461 | |
| deposit | 104461 | |
| non | 14587 | 6.1% |
| refund | 14587 | 6.1% |
| refundable | 162 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 223509 | |
| e | 119372 | |
| N | 119048 | |
| 119048 | ||
| s | 104461 | |
| i | 104461 | |
| t | 104461 | |
| p | 104461 | |
| D | 104461 | |
| n | 29336 | 2.5% |
| Other values (7) | 59482 | 5.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 834794 | |
| Uppercase Letter | 238258 | 20.0% |
| Space Separator | 119048 | 10.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 223509 | |
| e | 119372 | |
| s | 104461 | |
| i | 104461 | |
| t | 104461 | |
| p | 104461 | |
| n | 29336 | 3.5% |
| f | 14749 | 1.8% |
| u | 14749 | 1.8% |
| d | 14749 | 1.8% |
| Other values (3) | 486 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 119048 | |
| D | 104461 | |
| R | 14749 | 6.2% |
Space Separator
| Value | Count | Frequency (%) |
| 119048 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1073052 | |
| Common | 119048 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 223509 | |
| e | 119372 | |
| N | 119048 | |
| s | 104461 | |
| i | 104461 | |
| t | 104461 | |
| p | 104461 | |
| D | 104461 | |
| n | 29336 | 2.7% |
| R | 14749 | 1.4% |
| Other values (6) | 44733 | 4.2% |
Common
| Value | Count | Frequency (%) |
| 119048 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1192100 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 223509 | |
| e | 119372 | |
| N | 119048 | |
| 119048 | ||
| s | 104461 | |
| i | 104461 | |
| t | 104461 | |
| p | 104461 | |
| D | 104461 | |
| n | 29336 | 2.5% |
| Other values (7) | 59482 | 5.0% |
agent
Real number (ℝ)
ZEROS
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 74.889078 |
| Minimum | 0 |
|---|---|
| Maximum | 535 |
| Zeros | 16280 |
| Zeros (%) | 13.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7 |
| median | 9 |
| Q3 | 152 |
| 95-th percentile | 250 |
| Maximum | 535 |
| Range | 535 |
| Interquartile range (IQR) | 145 |
Descriptive statistics
| Standard deviation | 107.16888 |
|---|---|
| Coefficient of variation (CV) | 1.4310349 |
| Kurtosis | 0.50744609 |
| Mean | 74.889078 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 1.2985454 |
| Sum | 8927527 |
| Variance | 11485.17 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9 | 31922 | |
| 0 | 16280 | |
| 240 | 13922 | |
| 1 | 7187 | 6.0% |
| 14 | 3633 | 3.0% |
| 7 | 3532 | 3.0% |
| 6 | 3290 | 2.8% |
| 250 | 2870 | 2.4% |
| 241 | 1721 | 1.4% |
| 28 | 1657 | 1.4% |
| Other values (324) | 33196 |
| Value | Count | Frequency (%) |
| 0 | 16280 | |
| 1 | 7187 | 6.0% |
| 2 | 162 | 0.1% |
| 3 | 1336 | 1.1% |
| 4 | 47 | < 0.1% |
| 5 | 330 | 0.3% |
| 6 | 3290 | 2.8% |
| 7 | 3532 | 3.0% |
| 8 | 1514 | 1.3% |
| 9 | 31922 |
| Value | Count | Frequency (%) |
| 535 | 3 | < 0.1% |
| 531 | 68 | |
| 527 | 35 | |
| 526 | 10 | < 0.1% |
| 510 | 2 | < 0.1% |
| 509 | 10 | < 0.1% |
| 508 | 6 | < 0.1% |
| 502 | 24 | < 0.1% |
| 497 | 1 | < 0.1% |
| 495 | 57 |
company
Real number (ℝ)
ZEROS
| Distinct | 349 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.7354 |
| Minimum | 0 |
|---|---|
| Maximum | 543 |
| Zeros | 112442 |
| Zeros (%) | 94.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 40 |
| Maximum | 543 |
| Range | 543 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 53.830143 |
|---|---|
| Coefficient of variation (CV) | 5.0142654 |
| Kurtosis | 37.898876 |
| Mean | 10.7354 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.9292756 |
| Sum | 1279767 |
| Variance | 2897.6843 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 112442 | |
| 40 | 924 | 0.8% |
| 223 | 784 | 0.7% |
| 67 | 267 | 0.2% |
| 45 | 249 | 0.2% |
| 153 | 213 | 0.2% |
| 174 | 147 | 0.1% |
| 219 | 141 | 0.1% |
| 281 | 138 | 0.1% |
| 154 | 133 | 0.1% |
| Other values (339) | 3772 | 3.2% |
| Value | Count | Frequency (%) |
| 0 | 112442 | |
| 6 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 37 | < 0.1% |
| 10 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 12 | 14 | < 0.1% |
| 14 | 9 | < 0.1% |
| 16 | 5 | < 0.1% |
| 18 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 543 | 2 | < 0.1% |
| 541 | 1 | < 0.1% |
| 539 | 2 | < 0.1% |
| 534 | 2 | < 0.1% |
| 531 | 1 | < 0.1% |
| 530 | 5 | < 0.1% |
| 528 | 2 | < 0.1% |
| 525 | 15 | |
| 523 | 17 | |
| 521 | 7 |
days_in_waiting_list
Real number (ℝ)
ZEROS
| Distinct | 127 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.3212147 |
| Minimum | 0 |
|---|---|
| Maximum | 391 |
| Zeros | 115517 |
| Zeros (%) | 96.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 17.598002 |
|---|---|
| Coefficient of variation (CV) | 7.5813763 |
| Kurtosis | 186.89459 |
| Mean | 2.3212147 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.948868 |
| Sum | 276712 |
| Variance | 309.68967 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 115517 | |
| 39 | 227 | 0.2% |
| 58 | 164 | 0.1% |
| 44 | 141 | 0.1% |
| 31 | 127 | 0.1% |
| 35 | 96 | 0.1% |
| 46 | 94 | 0.1% |
| 69 | 89 | 0.1% |
| 63 | 83 | 0.1% |
| 87 | 80 | 0.1% |
| Other values (117) | 2592 | 2.2% |
| Value | Count | Frequency (%) |
| 0 | 115517 | |
| 1 | 12 | < 0.1% |
| 2 | 5 | < 0.1% |
| 3 | 59 | < 0.1% |
| 4 | 25 | < 0.1% |
| 5 | 8 | < 0.1% |
| 6 | 15 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 7 | < 0.1% |
| 9 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 391 | 45 | |
| 379 | 15 | < 0.1% |
| 330 | 15 | < 0.1% |
| 259 | 10 | < 0.1% |
| 236 | 35 | |
| 224 | 10 | < 0.1% |
| 223 | 61 | |
| 215 | 21 | < 0.1% |
| 207 | 15 | < 0.1% |
| 193 | 1 | < 0.1% |
customer_type
Categorical
IMBALANCE
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.7 MiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 4072 |
| Group | 574 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.209295 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1217050 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient |
| 3rd row | Transient |
| 4th row | Transient |
| 5th row | Transient |
Common Values
| Value | Count | Frequency (%) |
| Transient | 89476 | |
| Transient-Party | 25088 | 21.0% |
| Contract | 4072 | 3.4% |
| Group | 574 | 0.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| transient | 89476 | |
| transient-party | 25088 | 21.0% |
| contract | 4072 | 3.4% |
| group | 574 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 233200 | |
| t | 147796 | |
| r | 144298 | |
| a | 143724 | |
| T | 114564 | |
| s | 114564 | |
| i | 114564 | |
| e | 114564 | |
| y | 25088 | 2.1% |
| - | 25088 | 2.1% |
| Other values (7) | 39600 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1047664 | |
| Uppercase Letter | 144298 | 11.9% |
| Dash Punctuation | 25088 | 2.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 233200 | |
| t | 147796 | |
| r | 144298 | |
| a | 143724 | |
| s | 114564 | |
| i | 114564 | |
| e | 114564 | |
| y | 25088 | 2.4% |
| o | 4646 | 0.4% |
| c | 4072 | 0.4% |
| Other values (2) | 1148 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 114564 | |
| P | 25088 | 17.4% |
| C | 4072 | 2.8% |
| G | 574 | 0.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 25088 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1191962 | |
| Common | 25088 | 2.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 233200 | |
| t | 147796 | |
| r | 144298 | |
| a | 143724 | |
| T | 114564 | |
| s | 114564 | |
| i | 114564 | |
| e | 114564 | |
| y | 25088 | 2.1% |
| P | 25088 | 2.1% |
| Other values (6) | 14512 | 1.2% |
Common
| Value | Count | Frequency (%) |
| - | 25088 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1217050 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 233200 | |
| t | 147796 | |
| r | 144298 | |
| a | 143724 | |
| T | 114564 | |
| s | 114564 | |
| i | 114564 | |
| e | 114564 | |
| y | 25088 | 2.1% |
| - | 25088 | 2.1% |
| Other values (7) | 39600 | 3.3% |
adr
Real number (ℝ)
ZEROS
| Distinct | 8866 |
|---|---|
| Distinct (%) | 7.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.96909 |
| Minimum | -6.38 |
|---|---|
| Maximum | 5400 |
| Zeros | 1810 |
| Zeros (%) | 1.5% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | -6.38 |
|---|---|
| 5-th percentile | 39 |
| Q1 | 69.5 |
| median | 94.95 |
| Q3 | 126 |
| 95-th percentile | 193.5 |
| Maximum | 5400 |
| Range | 5406.38 |
| Interquartile range (IQR) | 56.5 |
Descriptive statistics
| Standard deviation | 50.434007 |
|---|---|
| Coefficient of variation (CV) | 0.49460092 |
| Kurtosis | 1022.8267 |
| Mean | 101.96909 |
| Median Absolute Deviation (MAD) | 27.95 |
| Skewness | 10.612728 |
| Sum | 12155735 |
| Variance | 2543.589 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 62 | 3754 | 3.1% |
| 75 | 2715 | 2.3% |
| 90 | 2472 | 2.1% |
| 65 | 2418 | 2.0% |
| 80 | 1889 | 1.6% |
| 0 | 1810 | 1.5% |
| 95 | 1661 | 1.4% |
| 120 | 1607 | 1.3% |
| 100 | 1573 | 1.3% |
| 85 | 1538 | 1.3% |
| Other values (8856) | 97773 |
| Value | Count | Frequency (%) |
| -6.38 | 1 | < 0.1% |
| 0 | 1810 | |
| 0.26 | 1 | < 0.1% |
| 0.5 | 1 | < 0.1% |
| 1 | 14 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| 1.56 | 2 | < 0.1% |
| 1.6 | 1 | < 0.1% |
| 1.8 | 1 | < 0.1% |
| 2 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 5400 | 1 | |
| 510 | 1 | |
| 508 | 1 | |
| 451.5 | 1 | |
| 450 | 1 | |
| 437 | 1 | |
| 426.25 | 1 | |
| 402 | 1 | |
| 397.38 | 1 | |
| 392 | 2 |
required_car_parking_spaces
Categorical
IMBALANCE
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 MiB |
| 0 | |
|---|---|
| 1 | 7376 |
| 2 | 28 |
| 3 | 3 |
| 8 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 119210 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 111801 | |
| 1 | 7376 | 6.2% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 111801 | |
| 1 | 7376 | 6.2% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 111801 | |
| 1 | 7376 | 6.2% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 119210 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 111801 | |
| 1 | 7376 | 6.2% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 119210 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 111801 | |
| 1 | 7376 | 6.2% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 119210 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 111801 | |
| 1 | 7376 | 6.2% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
total_of_special_requests
Real number (ℝ)
ZEROS
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.57150407 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 70201 |
| Zeros (%) | 58.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7928759 |
|---|---|
| Coefficient of variation (CV) | 1.3873495 |
| Kurtosis | 1.4926142 |
| Mean | 0.57150407 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.3490487 |
| Sum | 68129 |
| Variance | 0.62865219 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 70201 | |
| 1 | 33183 | |
| 2 | 12952 | 10.9% |
| 3 | 2494 | 2.1% |
| 4 | 340 | 0.3% |
| 5 | 40 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 70201 | |
| 1 | 33183 | |
| 2 | 12952 | 10.9% |
| 3 | 2494 | 2.1% |
| 4 | 340 | 0.3% |
| 5 | 40 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 40 | < 0.1% |
| 4 | 340 | 0.3% |
| 3 | 2494 | 2.1% |
| 2 | 12952 | 10.9% |
| 1 | 33183 | |
| 0 | 70201 |
reservation_status
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.5 MiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 1206 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.6191175 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1027485 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Check-Out |
|---|---|
| 2nd row | Check-Out |
| 3rd row | Check-Out |
| 4th row | Check-Out |
| 5th row | Check-Out |
Common Values
| Value | Count | Frequency (%) |
| Check-Out | 75011 | |
| Canceled | 42993 | |
| No-Show | 1206 | 1.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| check-out | 75011 | |
| canceled | 42993 | |
| no-show | 1206 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 160997 | |
| C | 118004 | |
| c | 118004 | |
| h | 76217 | |
| - | 76217 | |
| u | 75011 | |
| t | 75011 | |
| O | 75011 | |
| k | 75011 | |
| a | 42993 | 4.2% |
| Other values (7) | 135009 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 755841 | |
| Uppercase Letter | 195427 | 19.0% |
| Dash Punctuation | 76217 | 7.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 160997 | |
| c | 118004 | |
| h | 76217 | |
| u | 75011 | |
| t | 75011 | |
| k | 75011 | |
| a | 42993 | 5.7% |
| n | 42993 | 5.7% |
| l | 42993 | 5.7% |
| d | 42993 | 5.7% |
| Other values (2) | 3618 | 0.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 118004 | |
| O | 75011 | |
| N | 1206 | 0.6% |
| S | 1206 | 0.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 76217 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 951268 | |
| Common | 76217 | 7.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 160997 | |
| C | 118004 | |
| c | 118004 | |
| h | 76217 | |
| u | 75011 | |
| t | 75011 | |
| O | 75011 | |
| k | 75011 | |
| a | 42993 | 4.5% |
| n | 42993 | 4.5% |
| Other values (6) | 92016 |
Common
| Value | Count | Frequency (%) |
| - | 76217 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1027485 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 160997 | |
| C | 118004 | |
| c | 118004 | |
| h | 76217 | |
| - | 76217 | |
| u | 75011 | |
| t | 75011 | |
| O | 75011 | |
| k | 75011 | |
| a | 42993 | 4.2% |
| Other values (7) | 135009 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Resort Hotel | 0 | 342 | 2015 | July | 27 | 1 | 0 | 0 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 3 | No Deposit | 0.0 | 0.0 | 0 | Transient | 0.0 | 0 | 0 | Check-Out | 2015-07-01 |
| 1 | Resort Hotel | 0 | 737 | 2015 | July | 27 | 1 | 0 | 0 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 4 | No Deposit | 0.0 | 0.0 | 0 | Transient | 0.0 | 0 | 0 | Check-Out | 2015-07-01 |
| 2 | Resort Hotel | 0 | 7 | 2015 | July | 27 | 1 | 0 | 1 | 1 | 0.0 | 0 | BB | GBR | Direct | Direct | 0 | 0 | 0 | A | C | 0 | No Deposit | 0.0 | 0.0 | 0 | Transient | 75.0 | 0 | 0 | Check-Out | 2015-07-02 |
| 3 | Resort Hotel | 0 | 13 | 2015 | July | 27 | 1 | 0 | 1 | 1 | 0.0 | 0 | BB | GBR | Corporate | Corporate | 0 | 0 | 0 | A | A | 0 | No Deposit | 304.0 | 0.0 | 0 | Transient | 75.0 | 0 | 0 | Check-Out | 2015-07-02 |
| 4 | Resort Hotel | 0 | 14 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 240.0 | 0.0 | 0 | Transient | 98.0 | 0 | 1 | Check-Out | 2015-07-03 |
| 5 | Resort Hotel | 0 | 14 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 240.0 | 0.0 | 0 | Transient | 98.0 | 0 | 1 | Check-Out | 2015-07-03 |
| 6 | Resort Hotel | 0 | 0 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0 | No Deposit | 0.0 | 0.0 | 0 | Transient | 107.0 | 0 | 0 | Check-Out | 2015-07-03 |
| 7 | Resort Hotel | 0 | 9 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0.0 | 0 | FB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0 | No Deposit | 303.0 | 0.0 | 0 | Transient | 103.0 | 0 | 1 | Check-Out | 2015-07-03 |
| 8 | Resort Hotel | 1 | 85 | 2015 | July | 27 | 1 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 240.0 | 0.0 | 0 | Transient | 82.0 | 0 | 1 | Canceled | 2015-05-06 |
| 9 | Resort Hotel | 1 | 75 | 2015 | July | 27 | 1 | 0 | 3 | 2 | 0.0 | 0 | HB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 15.0 | 0.0 | 0 | Transient | 105.5 | 0 | 0 | Canceled | 2015-04-22 |
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119380 | City Hotel | 0 | 44 | 2017 | August | 35 | 31 | 1 | 3 | 2 | 0.0 | 0 | SC | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9.0 | 0.0 | 0 | Transient | 140.75 | 0 | 1 | Check-Out | 2017-09-04 |
| 119381 | City Hotel | 0 | 188 | 2017 | August | 35 | 31 | 2 | 3 | 2 | 0.0 | 0 | BB | DEU | Direct | Direct | 0 | 0 | 0 | A | A | 0 | No Deposit | 14.0 | 0.0 | 0 | Transient | 99.00 | 0 | 0 | Check-Out | 2017-09-05 |
| 119382 | City Hotel | 0 | 135 | 2017 | August | 35 | 30 | 2 | 4 | 3 | 0.0 | 0 | BB | JPN | Online TA | TA/TO | 0 | 0 | 0 | G | G | 0 | No Deposit | 7.0 | 0.0 | 0 | Transient | 209.00 | 0 | 0 | Check-Out | 2017-09-05 |
| 119383 | City Hotel | 0 | 164 | 2017 | August | 35 | 31 | 2 | 4 | 2 | 0.0 | 0 | BB | DEU | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 42.0 | 0.0 | 0 | Transient | 87.60 | 0 | 0 | Check-Out | 2017-09-06 |
| 119384 | City Hotel | 0 | 21 | 2017 | August | 35 | 30 | 2 | 5 | 2 | 0.0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 394.0 | 0.0 | 0 | Transient | 96.14 | 0 | 2 | Check-Out | 2017-09-06 |
| 119385 | City Hotel | 0 | 23 | 2017 | August | 35 | 30 | 2 | 5 | 2 | 0.0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 394.0 | 0.0 | 0 | Transient | 96.14 | 0 | 0 | Check-Out | 2017-09-06 |
| 119386 | City Hotel | 0 | 102 | 2017 | August | 35 | 31 | 2 | 5 | 3 | 0.0 | 0 | BB | FRA | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0 | No Deposit | 9.0 | 0.0 | 0 | Transient | 225.43 | 0 | 2 | Check-Out | 2017-09-07 |
| 119387 | City Hotel | 0 | 34 | 2017 | August | 35 | 31 | 2 | 5 | 2 | 0.0 | 0 | BB | DEU | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 9.0 | 0.0 | 0 | Transient | 157.71 | 0 | 4 | Check-Out | 2017-09-07 |
| 119388 | City Hotel | 0 | 109 | 2017 | August | 35 | 31 | 2 | 5 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 89.0 | 0.0 | 0 | Transient | 104.40 | 0 | 0 | Check-Out | 2017-09-07 |
| 119389 | City Hotel | 0 | 205 | 2017 | August | 35 | 29 | 2 | 7 | 2 | 0.0 | 0 | HB | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9.0 | 0.0 | 0 | Transient | 151.20 | 0 | 2 | Check-Out | 2017-09-07 |
Most frequently occurring
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5398 | City Hotel | 1 | 277 | 2016 | November | 46 | 7 | 1 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 0.0 | 0.0 | 0 | Transient | 100.0 | 0 | 0 | Canceled | 2016-04-04 | 180 |
| 4176 | City Hotel | 1 | 68 | 2016 | February | 8 | 17 | 0 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 1 | 0 | A | A | 0 | Non Refund | 37.0 | 0.0 | 0 | Transient | 75.0 | 0 | 0 | Canceled | 2016-01-06 | 150 |
| 5070 | City Hotel | 1 | 188 | 2016 | June | 25 | 15 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 119.0 | 0.0 | 39 | Transient | 130.0 | 0 | 0 | Canceled | 2016-01-18 | 109 |
| 4874 | City Hotel | 1 | 158 | 2016 | May | 22 | 24 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 37.0 | 0.0 | 31 | Transient | 130.0 | 0 | 0 | Canceled | 2016-01-18 | 101 |
| 3845 | City Hotel | 1 | 34 | 2015 | December | 50 | 8 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 1 | 0 | A | A | 0 | Non Refund | 19.0 | 0.0 | 0 | Transient | 90.0 | 0 | 0 | Canceled | 2015-11-17 | 100 |
| 3787 | City Hotel | 1 | 28 | 2017 | March | 9 | 2 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 0.0 | 0.0 | 0 | Transient | 95.0 | 0 | 0 | Canceled | 2017-02-02 | 99 |
| 3901 | City Hotel | 1 | 38 | 2017 | January | 2 | 14 | 0 | 1 | 1 | 0.0 | 0 | BB | PRT | Corporate | Corporate | 0 | 0 | 0 | A | A | 0 | Non Refund | 0.0 | 67.0 | 0 | Transient | 75.0 | 0 | 0 | Canceled | 2016-12-07 | 99 |
| 4867 | City Hotel | 1 | 156 | 2017 | April | 17 | 26 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 37.0 | 0.0 | 0 | Transient | 100.0 | 0 | 0 | Canceled | 2016-11-21 | 99 |
| 4200 | City Hotel | 1 | 71 | 2016 | June | 25 | 14 | 0 | 3 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 236.0 | 0.0 | 0 | Transient | 120.0 | 0 | 0 | Canceled | 2016-04-27 | 89 |
| 4934 | City Hotel | 1 | 166 | 2016 | November | 45 | 1 | 0 | 3 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 236.0 | 0.0 | 0 | Transient | 110.0 | 0 | 0 | Canceled | 2016-07-13 | 85 |